package com.hig.ledger.mapper;

import java.util.List;
import com.hig.ledger.domain.LedgerJobCertification;
import org.apache.ibatis.annotations.Select;

/**
 * 职业技能鉴定证书统计Mapper接口
 * 
 * @author scp
 * @date 2024-09-22
 */
public interface LedgerJobCertificationMapper 
{
    /**
     * 查询职业技能鉴定证书统计
     * 
     * @param id 职业技能鉴定证书统计ID
     * @return 职业技能鉴定证书统计
     */
    public LedgerJobCertification selectLedgerJobCertificationById(Long id);

    /**
     * 查询职业技能鉴定证书统计列表
     * 
     * @param ledgerJobCertification 职业技能鉴定证书统计
     * @return 职业技能鉴定证书统计集合
     */
    public List<LedgerJobCertification> selectLedgerJobCertificationList(LedgerJobCertification ledgerJobCertification);

    /**
     * 新增职业技能鉴定证书统计
     * 
     * @param ledgerJobCertification 职业技能鉴定证书统计
     * @return 结果
     */
    public int insertLedgerJobCertification(LedgerJobCertification ledgerJobCertification);
    @Select("SELECT IFNULL(MAX(id), 0) + 1 FROM ledger_job_certification")
    long getNextId();
    /**
     * 修改职业技能鉴定证书统计
     * 
     * @param ledgerJobCertification 职业技能鉴定证书统计
     * @return 结果
     */
    public int updateLedgerJobCertification(LedgerJobCertification ledgerJobCertification);

    /**
     * 删除职业技能鉴定证书统计
     * 
     * @param id 职业技能鉴定证书统计ID
     * @return 结果
     */
    public int deleteLedgerJobCertificationById(Long id);

    /**
     * 批量删除职业技能鉴定证书统计
     * 
     * @param ids 需要删除的数据ID
     * @return 结果
     */
    public int deleteLedgerJobCertificationByIds(Long[] ids);
}
